INSERT INTO ${tableName}(
<#list pkList as column>
        ${column.columnName},
</#list>
<#list dataList as column>
    <#if column_has_next>
        ${column.columnName},
    </#if>
    <#if !column_has_next>
        ${column.columnName}
    </#if>
</#list>
)
VALUES (
<#list pkList as column>
        '${column.columnValue}',
</#list>
<#list dataList as column>
    <#if column_has_next>
        '${column.columnValue}',
    </#if>
    <#if !column_has_next>
        '${column.columnValue}'
    </#if>
</#list>
)
ON DUPLICATE KEY UPDATE
<#list dataList as column>
    <#if column_has_next>
        <#if column.opeType=="MAX">
            ${column.columnName} = Max(${column.columnName},'${column.columnValue}'),
        </#if>
        <#if column.opeType=="MIN">
            ${column.columnName} = Min(${column.columnName},'${column.columnValue}'),
        </#if>
        <#if column.opeType=="ACCUMULATE">
            ${column.columnName} = ${column.columnName} + '${column.columnValue}',
        </#if>
        <#if column.opeType=="REPLACE">
            ${column.columnName} = '${column.columnValue}',
        </#if>
    </#if>
    <#if !column_has_next>
        <#if column.opeType=="MAX">
            ${column.columnName} = Max(${column.columnName},'${column.columnValue}')
        </#if>
        <#if column.opeType=="MIN">
            ${column.columnName} = Min(${column.columnName},'${column.columnValue}')
        </#if>
        <#if column.opeType=="ACCUMULATE">
            ${column.columnName} = ${column.columnName} + '${column.columnValue}'
        </#if>
        <#if column.opeType=="REPLACE">
            ${column.columnName} = '${column.columnValue}'
        </#if>
    </#if>
</#list>